/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50741 (5.7.41)
 Source Host           : localhost:3306
 Source Schema         : mall_tiny

 Target Server Type    : MySQL
 Target Server Version : 50741 (5.7.41)
 File Encoding         : 65001

 Date: 21/11/2025 16:50:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for common_advert
-- ----------------------------
DROP TABLE IF EXISTS `common_advert`;
CREATE TABLE `common_advert` (
                                 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
                                 `name` varchar(255) NOT NULL DEFAULT '' COMMENT '广告名称',
                                 `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0-未发布 1-已发布 2-已过期 3-取消发布',
                                 `start_time` datetime NOT NULL DEFAULT '2015-01-01 00:00:00' COMMENT '开始时间',
                                 `end_time` datetime NOT NULL DEFAULT '2015-01-01 00:00:00' COMMENT '结束时间',
                                 `position_id` int(11) NOT NULL DEFAULT '0' COMMENT '广告位位置',
                                 `content_json` text NOT NULL COMMENT '图片信息【json对象，内含图片链接，跳转链接，宽高比，标题，排序等】',
                                 `sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序 降序优先',
                                 `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
                                 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
                                 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
                                 `del_flag` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '删除标志：0-正常 1-删除',
                                 PRIMARY KEY (`id`) USING BTREE,
                                 KEY `idx_position_id` (`position_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='广告信息表';

-- ----------------------------
-- Records of common_advert
-- ----------------------------
BEGIN;
INSERT INTO `common_advert` (`id`, `name`, `status`, `start_time`, `end_time`, `position_id`, `content_json`, `sort`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (1, '234234', 1, '2025-11-20 00:00:00', '2025-11-29 00:00:00', 1, '{\"imageUrl\":\"http://localhost:8080/uploads/images/56290a7e-dc8d-48a6-8e26-9b1d30935bdc.jpeg\",\"linkUrl\":\"http://localhost:4001/#/product-detail?skuId=20\",\"width\":1080,\"height\":250,\"title\":\"xxxlsjdflaf\"}', 1, 'sdfasdfasfadf', '2025-11-21 11:00:38', '2025-11-21 14:29:26', 0);
INSERT INTO `common_advert` (`id`, `name`, `status`, `start_time`, `end_time`, `position_id`, `content_json`, `sort`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (2, '232434', 1, '2025-11-20 00:00:00', '2025-11-30 00:00:00', 1, '{\"imageUrl\":\"http://api.tiny.com/uploads/images/c930d7b6-b4a2-444a-9822-58e1aba7f2c5.png\",\"linkUrl\":\"http://localhost:4001/#/product-detail?skuId=18\",\"width\":1080,\"height\":250,\"title\":\"sfasdfads\"}', 1, 'asdfasdfa', '2025-11-21 16:46:48', '2025-11-21 16:46:48', 0);
COMMIT;

-- ----------------------------
-- Table structure for common_advert_position
-- ----------------------------
DROP TABLE IF EXISTS `common_advert_position`;
CREATE TABLE `common_advert_position` (
                                          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
                                          `name` varchar(255) NOT NULL DEFAULT '' COMMENT '广告位位置描述',
                                          `title` varchar(100) DEFAULT '' COMMENT '前台标题',
                                          `size_info` varchar(255) NOT NULL DEFAULT '' COMMENT '广告位尺寸【json：{"pc":{"width":1,"height":2},"m":{"width":1,"height":2}}】',
                                          `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态【1-启用，2-停用】',
                                          `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
                                          `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
                                          `del_flag` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '删除标志：0-正常 1-删除',
                                          PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='广告位置表';

-- ----------------------------
-- Records of common_advert_position
-- ----------------------------
BEGIN;
INSERT INTO `common_advert_position` (`id`, `name`, `title`, `size_info`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (1, '首页轮播图', '轮播图2', '300*1860', 1, '2025-11-21 02:23:50', '2025-11-21 10:35:28', 0);
INSERT INTO `common_advert_position` (`id`, `name`, `title`, `size_info`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (2, '234234', '234234', '234234', 1, '2025-11-21 10:35:42', '2025-11-21 10:35:42', 0);
COMMIT;

-- ----------------------------
-- Table structure for common_config
-- ----------------------------
DROP TABLE IF EXISTS `common_config`;
CREATE TABLE `common_config` (
                                 `id` int(11) NOT NULL AUTO_INCREMENT,
                                 `key` varchar(64) NOT NULL DEFAULT '' COMMENT '唯一key名称',
                                 `value` text NOT NULL COMMENT '内容',
                                 `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
                                 `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
                                 `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
                                 `del_flag` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '删除标志 0正常 1删除',
                                 PRIMARY KEY (`id`) USING BTREE,
                                 UNIQUE KEY `uni_key` (`key`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='公共配置表';

-- ----------------------------
-- Records of common_config
-- ----------------------------
BEGIN;
INSERT INTO `common_config` (`id`, `key`, `value`, `description`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 'home-ads', '1', '首页的广告位ID（不要删除）', 1763548749, 1763694682, 0);
INSERT INTO `common_config` (`id`, `key`, `value`, `description`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 'key-2', '234234234', 'sdfsdfasf', 1763549125, 1763549125, 0);
COMMIT;

-- ----------------------------
-- Table structure for oms_cart
-- ----------------------------
DROP TABLE IF EXISTS `oms_cart`;
CREATE TABLE `oms_cart` (
                            `cart_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                            `user_id` int(11) DEFAULT '0' COMMENT '顾客id',
                            `sku_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品id',
                            `qty` int(11) DEFAULT NULL COMMENT '个数',
                            `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商品备注（废弃）',
                            `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                            `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                            PRIMARY KEY (`cart_id`) USING BTREE,
                            KEY `idx_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COMMENT='购物车表';

-- ----------------------------
-- Records of oms_cart
-- ----------------------------
BEGIN;
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 1, 10, 2, 'jiaiaiai', '2025-10-29 23:13:52', '2025-11-19 17:17:20', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 2, 19, 4, '', '2025-11-15 22:51:00', '2025-11-18 17:27:45', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 2, 18, 3, '', '2025-11-15 23:03:45', '2025-11-18 17:27:45', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 2, 10, 3, '', '2025-11-15 23:05:18', '2025-11-18 17:27:45', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 0, 1, 4, '', '2025-11-15 23:19:08', '2025-11-15 23:19:11', 0);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 0, 19, 5, '', '2025-11-18 15:37:21', '2025-11-19 12:03:31', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 0, 2, 3, '', '2025-11-18 17:19:38', '2025-11-19 12:03:25', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 0, 17, 2, '', '2025-11-18 17:19:47', '2025-11-18 17:19:48', 0);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 2, 17, 2, '', '2025-11-18 17:27:33', '2025-11-18 17:27:45', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (10, 2, 20, 1, '', '2025-11-19 09:42:25', '2025-11-19 09:43:47', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (11, 2, 18, 1, '', '2025-11-19 09:51:45', '2025-11-19 09:51:54', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 2, 9, 1, '', '2025-11-19 09:52:04', '2025-11-19 09:52:08', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 2, 2, 1, '', '2025-11-19 09:52:15', '2025-11-19 09:52:20', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 2, 4, 2, '', '2025-11-19 09:52:37', '2025-11-19 09:52:42', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 2, 1, 1, '', '2025-11-19 09:52:51', '2025-11-19 09:52:55', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 2, 2, 2, '', '2025-11-19 09:53:01', '2025-11-19 09:53:05', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 2, 3, 2, '', '2025-11-19 09:53:10', '2025-11-19 09:53:15', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 2, 20, 1, '', '2025-11-19 09:54:20', '2025-11-19 09:54:27', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 2, 18, 3, '', '2025-11-19 09:55:58', '2025-11-19 09:56:13', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 2, 1, 2, '', '2025-11-19 09:56:36', '2025-11-19 16:45:07', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 2, 11, 1, '', '2025-11-19 10:05:42', '2025-11-19 10:15:21', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (22, 2, 19, 2, '', '2025-11-19 10:29:42', '2025-11-19 11:46:32', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (23, 2, 20, 1, '', '2025-11-19 11:24:31', '2025-11-19 11:41:54', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (24, 2, 19, 1, '', '2025-11-19 12:18:59', '2025-11-19 16:45:07', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (25, 1, 20, 2, '', '2025-11-19 17:17:12', '2025-11-19 17:17:20', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (26, 5, 19, 2, '', '2025-11-19 18:26:38', '2025-11-19 18:26:46', 1);
INSERT INTO `oms_cart` (`cart_id`, `user_id`, `sku_id`, `qty`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (27, 5, 18, 3, '', '2025-11-21 12:28:23', '2025-11-21 16:20:35', 1);
COMMIT;

-- ----------------------------
-- Table structure for oms_order
-- ----------------------------
DROP TABLE IF EXISTS `oms_order`;
CREATE TABLE `oms_order` (
                             `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                             `order_no` varchar(19) NOT NULL DEFAULT '0' COMMENT '订单编码',
                             `order_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '订单状态:0-询价，1-报价，2-设计，3-制作，4-配送/安装，5-结算资料对接，6-等待付款，7-已完成  8-已废弃。',
                             `user_id` int(11) DEFAULT '0' COMMENT '顾客id',
                             `pay_amount` int(11) DEFAULT '0' COMMENT '支付金额',
                             `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '订单备注',
                             `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                             `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                             `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                             PRIMARY KEY (`order_id`) USING BTREE,
                             KEY `idx_order_no` (`order_no`) USING BTREE,
                             KEY `idx_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of oms_order
-- ----------------------------
BEGIN;
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 's11190001', 0, 1, 220, 'bxxxx', '2025-10-27 15:11:20', '2025-10-27 15:11:24', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 'O202511181647474088', 0, 2, 10, '', '2025-11-18 16:47:47', '2025-11-18 16:47:47', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 'S202511181708156473', 0, 2, 673, '234234', '2025-11-18 17:08:15', '2025-11-18 17:08:15', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 'S202511181727449495', 7, 2, 864, 'ewreqwr', '2025-11-18 17:27:45', '2025-11-19 08:37:20', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 'S202511190943476792', 0, 2, 90, '234234', '2025-11-19 09:43:47', '2025-11-19 09:43:47', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 'S202511190951542319', 0, 2, 95, '234234', '2025-11-19 09:51:54', '2025-11-19 09:51:54', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 'S202511190952087443', 0, 2, 95, '', '2025-11-19 09:52:08', '2025-11-19 09:52:08', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 'S202511190952203129', 0, 2, 120, '234234', '2025-11-19 09:52:20', '2025-11-19 09:52:20', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 'S202511190952424332', 0, 2, 191, '', '2025-11-19 09:52:42', '2025-11-19 09:52:42', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (10, 'S202511190952548396', 0, 2, 200, '', '2025-11-19 09:52:54', '2025-11-19 09:52:54', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (11, 'S202511190953044135', 7, 2, 240, '', '2025-11-19 09:53:05', '2025-11-19 08:37:16', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 'S202511190953146956', 0, 2, 191, '', '2025-11-19 09:53:15', '2025-11-19 09:53:15', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 'S202511190954276318', 0, 2, 90, '23423423424234234234', '2025-11-19 09:54:27', '2025-11-19 09:54:27', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 'S202511190956138671', 0, 2, 287, '234234234', '2025-11-19 09:56:13', '2025-11-19 09:56:13', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 'S202511191141549415', 0, 2, 367, '23423422是的发生李开发', '2025-11-19 11:41:54', '2025-11-19 11:41:54', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 'S202511191146322404', 0, 2, 185, '234234', '2025-11-19 11:46:32', '2025-11-19 11:46:32', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 'S202511191154034140', 3, 2, 80, '234234', '2025-11-19 11:54:03', '2025-11-19 15:37:04', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 'S202511191645078369', 0, 2, 496, 'hahaha', '2025-11-19 16:45:07', '2025-11-19 16:45:07', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 'S202511191717196506', 0, 1, 183, '234234234', '2025-11-19 17:17:20', '2025-11-19 17:17:20', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 'S202511191826459707', 0, 5, 191, '四大分卫额发多少', '2025-11-19 18:26:46', '2025-11-19 18:26:46', 0);
INSERT INTO `oms_order` (`order_id`, `order_no`, `order_status`, `user_id`, `pay_amount`, `remark`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 'S202511211620341471', 0, 5, 287, '234234', '2025-11-21 16:20:35', '2025-11-21 16:20:35', 0);
COMMIT;

-- ----------------------------
-- Table structure for oms_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_goods`;
CREATE TABLE `oms_order_goods` (
                                   `order_goods_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                   `order_no` varchar(19) NOT NULL DEFAULT '0' COMMENT '订单编码',
                                   `user_id` int(11) DEFAULT '0' COMMENT '顾客id',
                                   `sku_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品id',
                                   `qty` int(11) DEFAULT NULL COMMENT '个数',
                                   `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商品备注',
                                   `sku_code` varchar(10) NOT NULL DEFAULT '0' COMMENT '商品编码',
                                   `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
                                   `main_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品主图',
                                   `crossed_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '划线价',
                                   `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '划线价',
                                   `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                   `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                   `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                                   PRIMARY KEY (`order_goods_id`) USING BTREE,
                                   KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='订单商品表';

-- ----------------------------
-- Records of oms_order_goods
-- ----------------------------
BEGIN;
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 's11190001', 1, 10, 1, 'xxx', '0xxx', '2333', '3.png', 200.00, 100.00, '2025-10-27 15:12:00', '2025-10-27 15:12:25', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 's11190001', 1, 9, 2, '222', '3330', '444', '2.png', 110.00, 220.00, '2025-10-27 15:13:01', '2025-10-27 15:13:01', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 'O202511181647474088', 2, 10, 3, '', 'SKU10', '商品10', '', 0.00, 0.00, '2025-11-18 16:47:47', '2025-11-18 16:47:47', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 'O202511181647474088', 2, 18, 3, '', 'SKU18', '商品18', '', 0.00, 0.00, '2025-11-18 16:47:47', '2025-11-18 16:47:47', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 'O202511181647474088', 2, 19, 4, '', 'SKU19', '商品19', '', 0.00, 0.00, '2025-11-18 16:47:47', '2025-11-18 16:47:47', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 'S202511181708156473', 2, 10, 3, '', '234234', '234234', '/img/70c804da-dfeb-4ff5-bcac-c5730a2af4d6.jpeg', 2.00, 1.00, '2025-11-18 17:08:15', '2025-11-18 17:08:15', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 'S202511181708156473', 2, 18, 3, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-18 17:08:15', '2025-11-18 17:08:15', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 'S202511181708156473', 2, 19, 4, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-18 17:08:15', '2025-11-18 17:08:15', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 'S202511181727449495', 2, 17, 2, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-18 17:27:45', '2025-11-18 17:27:45', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (10, 'S202511181727449495', 2, 10, 3, '', '234234', '234234', '/img/70c804da-dfeb-4ff5-bcac-c5730a2af4d6.jpeg', 2.00, 1.00, '2025-11-18 17:27:45', '2025-11-18 17:27:45', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (11, 'S202511181727449495', 2, 18, 3, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-18 17:27:45', '2025-11-18 17:27:45', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 'S202511181727449495', 2, 19, 4, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-18 17:27:45', '2025-11-18 17:27:45', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 'S202511190943476792', 2, 20, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 90.99, '2025-11-19 09:43:47', '2025-11-19 09:43:47', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 'S202511190951542319', 2, 18, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 09:51:54', '2025-11-19 09:51:54', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 'S202511190952087443', 2, 9, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 09:52:08', '2025-11-19 09:52:08', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 'S202511190952203129', 2, 2, 1, '', 'test2', 'test22222', '/images/2.webp', 212.00, 120.00, '2025-11-19 09:52:20', '2025-11-19 09:52:20', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 'S202511190952424332', 2, 4, 2, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 09:52:42', '2025-11-19 09:52:42', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 'S202511190952548396', 2, 1, 1, '', 'test1', 'test title22 update', '/images/1.webp', 300.99, 200.99, '2025-11-19 09:52:54', '2025-11-19 09:52:54', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 'S202511190953044135', 2, 2, 2, '', 'test2', 'test22222', '/images/2.webp', 212.00, 120.00, '2025-11-19 09:53:05', '2025-11-19 09:53:05', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 'S202511190953146956', 2, 3, 2, '', 'a12322', '22211211', '/images/3.webp', 100.00, 95.99, '2025-11-19 09:53:15', '2025-11-19 09:53:15', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 'S202511190954276318', 2, 20, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 90.99, '2025-11-19 09:54:27', '2025-11-19 09:54:27', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (22, 'S202511190956138671', 2, 18, 3, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 09:56:13', '2025-11-19 09:56:13', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (23, 'S202511191141549415', 2, 20, 3, '234234234', 'a12322', '测试富文本框', 'http://localhost:8080/uploads/images/2ddf363f-a01b-4228-9eb4-c73d524854a9.jpeg', 100.00, 90.99, '2025-11-19 11:41:54', '2025-11-19 11:41:54', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (24, 'S202511191141549415', 2, 18, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 11:41:54', '2025-11-19 11:41:54', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (25, 'S202511191146322404', 2, 19, 1, '234234', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 11:46:32', '2025-11-19 11:46:32', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (26, 'S202511191146322404', 2, 20, 1, '234234', 'a12322', '测试富文本框', 'http://localhost:8080/uploads/images/2ddf363f-a01b-4228-9eb4-c73d524854a9.jpeg', 100.00, 90.99, '2025-11-19 11:46:32', '2025-11-19 11:46:32', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (27, 'S202511191154034140', 2, 20, 1, '2342342', 'a12322', '测试富文本框', 'http://localhost:8080/uploads/images/2ddf363f-a01b-4228-9eb4-c73d524854a9.jpeg', 100.00, 90.99, '2025-11-19 11:54:03', '2025-11-19 11:54:03', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (28, 'S202511191645078369', 2, 19, 1, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 16:45:07', '2025-11-19 16:45:07', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (29, 'S202511191645078369', 2, 1, 2, '', 'test1', 'test title22 update', '/images/1.webp', 300.99, 200.99, '2025-11-19 16:45:07', '2025-11-19 16:45:07', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (30, 'S202511191717196506', 1, 20, 2, '', 'a12322', '测试富文本框', 'http://localhost:8080/uploads/images/2ddf363f-a01b-4228-9eb4-c73d524854a9.jpeg', 100.00, 90.99, '2025-11-19 17:17:20', '2025-11-19 17:17:20', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (31, 'S202511191717196506', 1, 10, 2, '', '234234', '234234', '/img/70c804da-dfeb-4ff5-bcac-c5730a2af4d6.jpeg', 2.00, 1.00, '2025-11-19 17:17:20', '2025-11-19 17:17:20', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (32, 'S202511191826459707', 5, 19, 2, '', 'a12322', '22211211', '/images/2.webp', 100.00, 95.99, '2025-11-19 18:26:46', '2025-11-19 18:26:46', 0);
INSERT INTO `oms_order_goods` (`order_goods_id`, `order_no`, `user_id`, `sku_id`, `qty`, `remark`, `sku_code`, `title`, `main_img`, `crossed_price`, `price`, `created_at`, `updated_at`, `del_flag`) VALUES (33, 'S202511211620341471', 5, 18, 3, '', 'a12322', '22211211', 'http://localhost:8080/uploads/images/cfa64fcd-9e3e-4102-aeaa-9741e37a7f71.png', 100.00, 95.99, '2025-11-21 16:20:35', '2025-11-21 16:20:35', 0);
COMMIT;

-- ----------------------------
-- Table structure for oms_order_log
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_log`;
CREATE TABLE `oms_order_log` (
                                 `order_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                 `order_no` varchar(19) NOT NULL DEFAULT '0' COMMENT '订单编码',
                                 `content` text COMMENT '日志内容',
                                 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                 `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                 `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                                 PRIMARY KEY (`order_log_id`) USING BTREE,
                                 KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COMMENT='订单日志表';

-- ----------------------------
-- Records of oms_order_log
-- ----------------------------
BEGIN;
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 's11190001', '22323232', '2025-10-27 15:13:21', '2025-10-27 15:13:21', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 'O202511181647474088', '创建订单', '2025-11-18 16:47:47', '2025-11-18 16:47:47', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 'S202511181708156473', '创建订单', '2025-11-18 17:08:15', '2025-11-18 17:08:15', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 'S202511181727449495', '创建订单', '2025-11-18 17:27:45', '2025-11-18 17:27:45', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 'S202511190943476792', '创建订单', '2025-11-19 09:43:47', '2025-11-19 09:43:47', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 'S202511190951542319', '创建订单', '2025-11-19 09:51:54', '2025-11-19 09:51:54', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 'S202511190952087443', '创建订单', '2025-11-19 09:52:08', '2025-11-19 09:52:08', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 'S202511190952203129', '创建订单', '2025-11-19 09:52:20', '2025-11-19 09:52:20', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 'S202511190952424332', '创建订单', '2025-11-19 09:52:42', '2025-11-19 09:52:42', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (10, 'S202511190952548396', '创建订单', '2025-11-19 09:52:55', '2025-11-19 09:52:55', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (11, 'S202511190953044135', '创建订单', '2025-11-19 09:53:05', '2025-11-19 09:53:05', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 'S202511190953146956', '创建订单', '2025-11-19 09:53:15', '2025-11-19 09:53:15', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 'S202511190954276318', '创建订单', '2025-11-19 09:54:27', '2025-11-19 09:54:27', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 'S202511190956138671', '创建订单', '2025-11-19 09:56:13', '2025-11-19 09:56:13', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 'S202511191141549415', '创建订单', '2025-11-19 11:41:54', '2025-11-19 11:41:54', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 'S202511191146322404', '创建订单', '2025-11-19 11:46:32', '2025-11-19 11:46:32', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 'S202511191154034140', '创建订单', '2025-11-19 11:54:03', '2025-11-19 11:54:03', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 'S202511191154034140', '订单从 0 变更为 1，备注：23423422', '2025-11-19 15:16:51', '2025-11-19 15:16:51', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 'S202511191154034140', '订单从 1 变更为 1，备注：23423422', '2025-11-19 15:16:58', '2025-11-19 15:16:58', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 'S202511191154034140', '订单从 1 变更为 2，备注：23423422', '2025-11-19 15:17:01', '2025-11-19 15:17:01', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 'S202511191154034140', '订单从 2 变更为 3，备注：234234', '2025-11-19 15:18:48', '2025-11-19 15:18:48', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (22, 'S202511191154034140', '订单从 制作 变更为 制作，备注：我加个备注', '2025-11-19 15:26:24', '2025-11-19 15:26:24', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (23, 'S202511191154034140', '订单金额从 90 变更为 80，备注：客气气', '2025-11-19 15:37:04', '2025-11-19 15:37:04', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (24, 'S202511191645078369', '创建订单', '2025-11-19 16:45:07', '2025-11-19 16:45:07', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (25, 'S202511191717196506', '创建订单', '2025-11-19 17:17:20', '2025-11-19 17:17:20', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (26, 'S202511191826459707', '创建订单', '2025-11-19 18:26:46', '2025-11-19 18:26:46', 0);
INSERT INTO `oms_order_log` (`order_log_id`, `order_no`, `content`, `created_at`, `updated_at`, `del_flag`) VALUES (27, 'S202511211620341471', '创建订单', '2025-11-21 16:20:35', '2025-11-21 16:20:35', 0);
COMMIT;

-- ----------------------------
-- Table structure for oms_user
-- ----------------------------
DROP TABLE IF EXISTS `oms_user`;
CREATE TABLE `oms_user` (
                            `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
                            `eid` varchar(60) NOT NULL DEFAULT '' COMMENT 'eid,前端唯一标识',
                            `phone` varchar(128) NOT NULL DEFAULT '' COMMENT '手机号',
                            `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
                            `name` varchar(256) NOT NULL DEFAULT '' COMMENT '名字',
                            `branch` varchar(255) NOT NULL DEFAULT '' COMMENT '网点',
                            `sex` tinyint(4) NOT NULL DEFAULT '3' COMMENT '1-男，2-女，3-未知',
                            `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户状态 1-生效,0-无效',
                            `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                            `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                            PRIMARY KEY (`user_id`) USING BTREE,
                            KEY `idx_eid` (`eid`) USING BTREE,
                            KEY `idx_phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of oms_user
-- ----------------------------
BEGIN;
INSERT INTO `oms_user` (`user_id`, `eid`, `phone`, `password`, `name`, `branch`, `sex`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (1, '2222', '15016712501', '$2a$10$csgzLcjF8BQxdTUtlOs8S.p3TbKeAY2leZ//NjJ73gRu8vPzCl3cS', 'xxx', 'xxx站点', 3, 1, '2025-10-27 14:13:24', '2025-11-19 14:38:57', 0);
INSERT INTO `oms_user` (`user_id`, `eid`, `phone`, `password`, `name`, `branch`, `sex`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (2, '', '123456', '$2a$10$qywcFNWcjXM6zo9wlN0ON.KmtAMDk3Viv5Ktm6qM1HHNF5zFKXUHS', 'yang', 'xxxxxx网点', 3, 1, '2025-11-15 09:50:19', '2025-11-19 12:31:49', 0);
INSERT INTO `oms_user` (`user_id`, `eid`, `phone`, `password`, `name`, `branch`, `sex`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (3, '', '13360502500', '$2a$10$K9UCLnyI9ewHaQBvyLZKOO8rPlY0gqUQZjqT.NqatyBJFQbWmyLVC', 'ssj', 'xxxjog网点', 3, 1, '2025-11-19 14:16:07', '2025-11-19 14:23:58', 0);
INSERT INTO `oms_user` (`user_id`, `eid`, `phone`, `password`, `name`, `branch`, `sex`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (4, '', '15016712500', '$2a$10$ra6pZvkfu62I/KikvtsZ6.tU7ie8zwHSJUF/y926ZY6H2fSaVSv6S', 'songssj', '测试编辑', 3, 1, '2025-11-19 14:24:29', '2025-11-19 14:31:09', 0);
INSERT INTO `oms_user` (`user_id`, `eid`, `phone`, `password`, `name`, `branch`, `sex`, `status`, `created_at`, `updated_at`, `del_flag`) VALUES (5, '', '17796335678', '$2a$10$Av6WkQW0DwBpGCtqsam/KOm9shIPbdUqgiS3OV1JgBZgXroKrkHAG', 'xxxjjj', '234234234', 3, 1, '2025-11-19 17:27:58', '2025-11-19 17:27:58', 0);
COMMIT;

-- ----------------------------
-- Table structure for pms_product_sku
-- ----------------------------
DROP TABLE IF EXISTS `pms_product_sku`;
CREATE TABLE `pms_product_sku` (
                                   `sku_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品主键id',
                                   `sku_code` varchar(10) NOT NULL DEFAULT '0' COMMENT '商品编码',
                                   `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
                                   `description` text COMMENT '描述',
                                   `main_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品主图',
                                   `crossed_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '划线价',
                                   `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '划线价',
                                   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序，从小到大排序',
                                   `is_show_to_user` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否给用户展示：1-展示，4-不展示',
                                   `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                   `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                   `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                                   PRIMARY KEY (`sku_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='商品sku表';

-- ----------------------------
-- Records of pms_product_sku
-- ----------------------------
BEGIN;
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 'test1', 'test title22 update', 'test description', '/images/1.webp', 300.99, 200.99, 0, 1, '2025-09-10 11:50:02', '2025-09-10 11:55:11', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 'test2', 'test22222', 'test2222222', '/images/2.webp', 212.00, 120.00, 1, 1, '2025-09-10 11:54:51', '2025-09-10 11:55:19', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 'a12322', '22211211', '123332', '/images/3.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:27:30', '2025-09-29 09:30:16', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:27:50', '2025-09-29 09:30:19', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:28:44', '2025-09-29 09:30:21', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:30:14', '2025-09-29 09:30:23', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:35:08', '2025-09-29 09:30:25', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:35:32', '2025-09-29 09:30:27', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-09-23 15:44:25', '2025-09-29 09:30:28', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (10, '234234', '234234', '234234', '/img/70c804da-dfeb-4ff5-bcac-c5730a2af4d6.jpeg', 2.00, 1.00, 3, 1, '2025-10-16 21:02:42', '2025-10-16 21:02:42', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (11, '234234', '234234', '234234', '/img/70c804da-dfeb-4ff5-bcac-c5730a2af4d6.jpeg', 2.00, 1.00, 3, 1, '2025-10-16 21:04:47', '2025-11-19 14:40:11', 1);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 9.99, 1, 1, '2025-10-17 10:37:18', '2025-10-17 10:52:30', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-10-17 10:37:27', '2025-10-17 10:37:27', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-10-17 10:37:52', '2025-10-17 10:37:52', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-10-17 10:38:55', '2025-10-17 10:38:55', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-10-17 10:39:10', '2025-10-17 10:39:10', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 95.99, 1, 1, '2025-10-17 10:39:22', '2025-10-17 10:39:22', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 'a12322', '22211211', '<p>123332234234</p><p><img src=\"http://localhost:8080/uploads/editor/d607f45c-e2ac-44f7-888a-c707c25e843e.jpg\" alt=\"8937e9b4b1d287e2a5178db426a696c3.jpg\" data-href=\"\" style=\"\"/></p>', 'http://localhost:8080/uploads/images/cfa64fcd-9e3e-4102-aeaa-9741e37a7f71.png', 100.00, 95.99, 1, 1, '2025-10-17 10:39:22', '2025-11-21 11:53:38', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 'a12322', '22211211', '<p>123332</p>', '/uploads/images/e379aac0-d21e-4bdd-ac8c-6355c80ac9aa.jpg', 100.00, 95.99, 1, 1, '2025-10-17 10:44:38', '2025-11-21 11:08:50', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 'a12322', '测试富文本框', '<p>24234234</p><p style=\"text-align: right;\"><u><strong>😆xxxxlslsljsjslls</strong></u></p><p style=\"text-align: center;\"><span style=\"color: rgb(225, 60, 57);\">sfasdfasdf</span></p><p style=\"text-align: center;\"><img src=\"http://localhost:8080/uploads/editor/b7b8172d-8695-4a32-b798-fed64bed2093.jpeg\" alt=\"20250926-183029.jpeg\" data-href=\"\" style=\"width: 308.50px;height: 308.50px;\"></p><p style=\"text-align: center;\"><img src=\"http://api.tiny.com/uploads/editor/ab5495b0-3f34-4e82-806e-aaeb6e9b6fc6.jpg\" alt=\"2020年工作小结.jpg\" data-href=\"\" style=\"\"></p>', 'http://api.tiny.com/uploads/images/72bc9a93-7c32-4a88-9a1d-fee2ff3143ff.jpg', 100.00, 90.99, 1, 1, '2025-10-17 10:45:00', '2025-11-21 16:45:32', 0);
INSERT INTO `pms_product_sku` (`sku_id`, `sku_code`, `title`, `description`, `main_img`, `crossed_price`, `price`, `sort`, `is_show_to_user`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 'a12322', '22211211', '123332', '/images/2.webp', 100.00, 9.99, 1, 1, '2025-10-17 10:50:08', '2025-10-21 20:54:26', 1);
COMMIT;

-- ----------------------------
-- Table structure for pms_product_sku_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `pms_product_sku_attr_value`;
CREATE TABLE `pms_product_sku_attr_value` (
                                              `id` int(11) NOT NULL AUTO_INCREMENT,
                                              `sku_id` int(11) NOT NULL COMMENT 'sku id',
                                              `pn_value` varchar(100) NOT NULL DEFAULT '' COMMENT '自定义属性',
                                              `pv_value` varchar(100) NOT NULL DEFAULT '' COMMENT '自定义属性值',
                                              `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                              `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                              `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除：0-正常，1-已删除',
                                              PRIMARY KEY (`id`) USING BTREE,
                                              KEY `idx_sku_id` (`sku_id`) USING BTREE,
                                              KEY `idx_pv_value` (`pv_value`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='sku属性属性值表';

-- ----------------------------
-- Records of pms_product_sku_attr_value
-- ----------------------------
BEGIN;
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (1, 9, '颜色', '白色', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (2, 10, '1111', '222', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (3, 10, '22', '333', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (4, 11, '1111', '222', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (5, 11, '22', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (6, 12, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (7, 12, '333', '444', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (8, 13, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (9, 13, '333', '444', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (10, 14, '234234', '23434', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (11, 15, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (12, 16, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (13, 17, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (14, 18, '234234', '234234', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (15, 19, '23434', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (16, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (17, 21, '2233', '3333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (18, 12, '1122', '122', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (19, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (20, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (21, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (22, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (23, 20, '22333', '333', NULL, NULL, 1);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (24, 19, '23434', '333', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (25, 18, '234234', '234234', NULL, NULL, 0);
INSERT INTO `pms_product_sku_attr_value` (`id`, `sku_id`, `pn_value`, `pv_value`, `created_at`, `updated_at`, `del_flag`) VALUES (26, 20, '22333', '333', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for ums_admin
-- ----------------------------
DROP TABLE IF EXISTS `ums_admin`;
CREATE TABLE `ums_admin` (
                             `id` bigint(20) NOT NULL AUTO_INCREMENT,
                             `username` varchar(64) DEFAULT NULL,
                             `password` varchar(64) DEFAULT NULL,
                             `icon` varchar(500) DEFAULT NULL COMMENT '头像',
                             `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
                             `nick_name` varchar(200) DEFAULT NULL COMMENT '昵称',
                             `note` varchar(500) DEFAULT NULL COMMENT '备注信息',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
                             `status` int(1) DEFAULT '1' COMMENT '帐号启用状态：0->禁用；1->启用',
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='后台用户表';

-- ----------------------------
-- Records of ums_admin
-- ----------------------------
BEGIN;
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (1, 'test', '$2a$10$NZ5o7r2E.ayT2ZoxgjlI.eJ6OEYqjH7INR/F.mXDbjZJi9HF0YCVG', 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/timg.jpg', 'test@qq.com', '测试账号', NULL, '2018-09-29 13:55:30', '2018-09-29 13:55:39', 1);
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (3, 'admin', '$2a$10$.E1FokumK5GIXWgKlg.Hc.i/0/2.qdAwYFL1zc5QHdyzpXOr38RZO', 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/timg.jpg', 'admin@163.com', '系统管理员', '系统管理员', '2018-10-08 13:32:47', '2019-04-20 12:45:16', 1);
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (4, 'macro', '$2a$10$Bx4jZPR7GhEpIQfefDQtVeS58GfT5n6mxs/b4nLLK65eMFa16topa', 'string', 'macro@qq.com', 'macro', 'macro专用', '2019-10-06 15:53:51', '2020-02-03 14:55:55', 1);
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (6, 'productAdmin', '$2a$10$6/.J.p.6Bhn7ic4GfoB5D.pGd7xSiD1a9M6ht6yO0fxzlKJPjRAGm', NULL, 'product@qq.com', '商品管理员', '只有商品权限', '2020-02-07 16:15:08', NULL, 1);
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (7, 'orderAdmin', '$2a$10$UqEhA9UZXjHHA3B.L9wNG.6aerrBjC6WHTtbv1FdvYPUI.7lkL6E.', NULL, 'order@qq.com', '订单管理员', '只有订单管理权限', '2020-02-07 16:15:50', NULL, 1);
INSERT INTO `ums_admin` (`id`, `username`, `password`, `icon`, `email`, `nick_name`, `note`, `create_time`, `login_time`, `status`) VALUES (10, 'ceshi', '$2a$10$RaaNo9CC0RSms8mc/gJpCuOWndDT4pHH0u5XgZdAAYFs1Uq4sOPRi', NULL, 'ceshi@qq.com', 'ceshi', NULL, '2020-03-13 16:23:30', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for ums_admin_login_log
-- ----------------------------
DROP TABLE IF EXISTS `ums_admin_login_log`;
CREATE TABLE `ums_admin_login_log` (
                                       `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                       `admin_id` bigint(20) DEFAULT NULL,
                                       `create_time` datetime DEFAULT NULL,
                                       `ip` varchar(64) DEFAULT NULL,
                                       `address` varchar(100) DEFAULT NULL,
                                       `user_agent` varchar(100) DEFAULT NULL COMMENT '浏览器登录类型',
                                       PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=287 DEFAULT CHARSET=utf8 COMMENT='后台用户登录日志表';

-- ----------------------------
-- Records of ums_admin_login_log
-- ----------------------------
BEGIN;
INSERT INTO `ums_admin_login_log` (`id`, `admin_id`, `create_time`, `ip`, `address`, `user_agent`) VALUES (285, 3, '2020-08-24 14:05:21', '0:0:0:0:0:0:0:1', NULL, NULL);
INSERT INTO `ums_admin_login_log` (`id`, `admin_id`, `create_time`, `ip`, `address`, `user_agent`) VALUES (286, 10, '2020-08-24 14:05:39', '0:0:0:0:0:0:0:1', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ums_admin_role_relation
-- ----------------------------
DROP TABLE IF EXISTS `ums_admin_role_relation`;
CREATE TABLE `ums_admin_role_relation` (
                                           `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                           `admin_id` bigint(20) DEFAULT NULL,
                                           `role_id` bigint(20) DEFAULT NULL,
                                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='后台用户和角色关系表';

-- ----------------------------
-- Records of ums_admin_role_relation
-- ----------------------------
BEGIN;
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (26, 3, 5);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (27, 6, 1);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (28, 7, 2);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (29, 1, 5);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (30, 4, 5);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (31, 8, 5);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (34, 12, 6);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (38, 13, 5);
INSERT INTO `ums_admin_role_relation` (`id`, `admin_id`, `role_id`) VALUES (39, 10, 8);
COMMIT;

-- ----------------------------
-- Table structure for ums_menu
-- ----------------------------
DROP TABLE IF EXISTS `ums_menu`;
CREATE TABLE `ums_menu` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `parent_id` bigint(20) DEFAULT NULL COMMENT '父级ID',
                            `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                            `title` varchar(100) DEFAULT NULL COMMENT '菜单名称',
                            `level` int(4) DEFAULT NULL COMMENT '菜单级数',
                            `sort` int(4) DEFAULT NULL COMMENT '菜单排序',
                            `name` varchar(100) DEFAULT NULL COMMENT '前端名称',
                            `icon` varchar(200) DEFAULT NULL COMMENT '前端图标',
                            `hidden` int(1) DEFAULT NULL COMMENT '前端隐藏',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';

-- ----------------------------
-- Records of ums_menu
-- ----------------------------
BEGIN;
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (1, 0, '2020-02-02 14:50:36', '商品', 0, 0, 'pms', 'product', 1);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (2, 1, '2020-02-02 14:51:50', '商品列表', 1, 0, 'product', 'product-list', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (3, 1, '2020-02-02 14:52:44', '添加商品', 1, 0, 'addProduct', 'product-add', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (4, 1, '2020-02-02 14:53:51', '商品分类', 1, 0, 'productCate', 'product-cate', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (5, 1, '2020-02-02 14:54:51', '商品类型', 1, 0, 'productAttr', 'product-attr', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (6, 1, '2020-02-02 14:56:29', '品牌管理', 1, 0, 'brand', 'product-brand', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (7, 0, '2020-02-02 16:54:07', '订单', 0, 0, 'oms', 'order', 1);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (8, 7, '2020-02-02 16:55:18', '订单列表', 1, 0, 'order', 'product-list', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (9, 7, '2020-02-02 16:56:46', '订单设置', 1, 0, 'orderSetting', 'order-setting', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (10, 7, '2020-02-02 16:57:39', '退货申请处理', 1, 0, 'returnApply', 'order-return', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (11, 7, '2020-02-02 16:59:40', '退货原因设置', 1, 0, 'returnReason', 'order-return-reason', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (12, 0, '2020-02-04 16:18:00', '营销', 0, 0, 'sms', 'sms', 1);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (13, 12, '2020-02-04 16:19:22', '秒杀活动列表', 1, 0, 'flash', 'sms-flash', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (14, 12, '2020-02-04 16:20:16', '优惠券列表', 1, 0, 'coupon', 'sms-coupon', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (16, 12, '2020-02-07 16:22:38', '品牌推荐', 1, 0, 'homeBrand', 'product-brand', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (17, 12, '2020-02-07 16:23:14', '新品推荐', 1, 0, 'homeNew', 'sms-new', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (18, 12, '2020-02-07 16:26:38', '人气推荐', 1, 0, 'homeHot', 'sms-hot', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (19, 12, '2020-02-07 16:28:16', '专题推荐', 1, 0, 'homeSubject', 'sms-subject', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (20, 12, '2020-02-07 16:28:42', '广告列表', 1, 0, 'homeAdvertise', 'sms-ad', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (21, 0, '2020-02-07 16:29:13', '权限', 0, 0, 'ums', 'ums', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (22, 21, '2020-02-07 16:29:51', '用户列表', 1, 0, 'admin', 'ums-admin', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (23, 21, '2020-02-07 16:30:13', '角色列表', 1, 0, 'role', 'ums-role', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (24, 21, '2020-02-07 16:30:53', '菜单列表', 1, 0, 'menu', 'ums-menu', 0);
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (25, 21, '2020-02-07 16:31:13', '资源列表', 1, 0, 'resource', 'ums-resource', 0);
COMMIT;

-- ----------------------------
-- Table structure for ums_resource
-- ----------------------------
DROP TABLE IF EXISTS `ums_resource`;
CREATE TABLE `ums_resource` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                `name` varchar(200) DEFAULT NULL COMMENT '资源名称',
                                `url` varchar(200) DEFAULT NULL COMMENT '资源URL',
                                `description` varchar(500) DEFAULT NULL COMMENT '描述',
                                `category_id` bigint(20) DEFAULT NULL COMMENT '资源分类ID',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='后台资源表';

-- ----------------------------
-- Records of ums_resource
-- ----------------------------
BEGIN;
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (1, '2020-02-04 17:04:55', '商品品牌管理', '/brand/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (2, '2020-02-04 17:05:35', '商品属性分类管理', '/productAttribute/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (3, '2020-02-04 17:06:13', '商品属性管理', '/productAttribute/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (4, '2020-02-04 17:07:15', '商品分类管理', '/productCategory/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (5, '2020-02-04 17:09:16', '商品管理', '/product/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (6, '2020-02-04 17:09:53', '商品库存管理', '/sku/**', NULL, 1);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (8, '2020-02-05 14:43:37', '订单管理', '/order/**', '', 2);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (9, '2020-02-05 14:44:22', ' 订单退货申请管理', '/returnApply/**', '', 2);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (10, '2020-02-05 14:45:08', '退货原因管理', '/returnReason/**', '', 2);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (11, '2020-02-05 14:45:43', '订单设置管理', '/orderSetting/**', '', 2);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (12, '2020-02-05 14:46:23', '收货地址管理', '/companyAddress/**', '', 2);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (13, '2020-02-07 16:37:22', '优惠券管理', '/coupon/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (14, '2020-02-07 16:37:59', '优惠券领取记录管理', '/couponHistory/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (15, '2020-02-07 16:38:28', '限时购活动管理', '/flash/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (16, '2020-02-07 16:38:59', '限时购商品关系管理', '/flashProductRelation/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (17, '2020-02-07 16:39:22', '限时购场次管理', '/flashSession/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (18, '2020-02-07 16:40:07', '首页轮播广告管理', '/home/advertise/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (19, '2020-02-07 16:40:34', '首页品牌管理', '/home/brand/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (20, '2020-02-07 16:41:06', '首页新品管理', '/home/newProduct/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (21, '2020-02-07 16:42:16', '首页人气推荐管理', '/home/recommendProduct/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (22, '2020-02-07 16:42:48', '首页专题推荐管理', '/home/recommendSubject/**', '', 3);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (23, '2020-02-07 16:44:56', ' 商品优选管理', '/prefrenceArea/**', '', 5);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (24, '2020-02-07 16:45:39', '商品专题管理', '/subject/**', '', 5);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (25, '2020-02-07 16:47:34', '后台用户管理', '/admin/**', '', 4);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (26, '2020-02-07 16:48:24', '后台用户角色管理', '/role/**', '', 4);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (27, '2020-02-07 16:48:48', '后台菜单管理', '/menu/**', '', 4);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (28, '2020-02-07 16:49:18', '后台资源分类管理', '/resourceCategory/**', '', 4);
INSERT INTO `ums_resource` (`id`, `create_time`, `name`, `url`, `description`, `category_id`) VALUES (29, '2020-02-07 16:49:45', '后台资源管理', '/resource/**', '', 4);
COMMIT;

-- ----------------------------
-- Table structure for ums_resource_category
-- ----------------------------
DROP TABLE IF EXISTS `ums_resource_category`;
CREATE TABLE `ums_resource_category` (
                                         `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                         `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                         `name` varchar(200) DEFAULT NULL COMMENT '分类名称',
                                         `sort` int(4) DEFAULT NULL COMMENT '排序',
                                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='资源分类表';

-- ----------------------------
-- Records of ums_resource_category
-- ----------------------------
BEGIN;
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (1, '2020-02-05 10:21:44', '商品模块', 0);
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (2, '2020-02-05 10:22:34', '订单模块', 0);
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (3, '2020-02-05 10:22:48', '营销模块', 0);
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (4, '2020-02-05 10:23:04', '权限模块', 0);
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (5, '2020-02-07 16:34:27', '内容模块', 0);
INSERT INTO `ums_resource_category` (`id`, `create_time`, `name`, `sort`) VALUES (6, '2020-02-07 16:35:49', '其他模块', 0);
COMMIT;

-- ----------------------------
-- Table structure for ums_role
-- ----------------------------
DROP TABLE IF EXISTS `ums_role`;
CREATE TABLE `ums_role` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `name` varchar(100) DEFAULT NULL COMMENT '名称',
                            `description` varchar(500) DEFAULT NULL COMMENT '描述',
                            `admin_count` int(11) DEFAULT NULL COMMENT '后台用户数量',
                            `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                            `status` int(1) DEFAULT '1' COMMENT '启用状态：0->禁用；1->启用',
                            `sort` int(11) DEFAULT '0',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='后台用户角色表';

-- ----------------------------
-- Records of ums_role
-- ----------------------------
BEGIN;
INSERT INTO `ums_role` (`id`, `name`, `description`, `admin_count`, `create_time`, `status`, `sort`) VALUES (1, '商品管理员', '只能查看及操作商品', 0, '2020-02-03 16:50:37', 1, 0);
INSERT INTO `ums_role` (`id`, `name`, `description`, `admin_count`, `create_time`, `status`, `sort`) VALUES (2, '订单管理员', '只能查看及操作订单', 0, '2018-09-30 15:53:45', 1, 0);
INSERT INTO `ums_role` (`id`, `name`, `description`, `admin_count`, `create_time`, `status`, `sort`) VALUES (5, '超级管理员', '拥有所有查看和操作功能', 0, '2020-02-02 15:11:05', 1, 0);
INSERT INTO `ums_role` (`id`, `name`, `description`, `admin_count`, `create_time`, `status`, `sort`) VALUES (8, '权限管理员', '用于权限模块所有操作功能', 0, '2020-08-24 10:57:35', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for ums_role_menu_relation
-- ----------------------------
DROP TABLE IF EXISTS `ums_role_menu_relation`;
CREATE TABLE `ums_role_menu_relation` (
                                          `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                          `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
                                          `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
                                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='后台角色菜单关系表';

-- ----------------------------
-- Records of ums_role_menu_relation
-- ----------------------------
BEGIN;
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (33, 1, 1);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (34, 1, 2);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (35, 1, 3);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (36, 1, 4);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (37, 1, 5);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (38, 1, 6);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (53, 2, 7);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (54, 2, 8);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (55, 2, 9);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (56, 2, 10);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (57, 2, 11);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (72, 5, 1);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (73, 5, 2);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (74, 5, 3);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (75, 5, 4);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (76, 5, 5);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (77, 5, 6);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (78, 5, 7);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (79, 5, 8);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (80, 5, 9);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (81, 5, 10);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (82, 5, 11);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (83, 5, 12);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (84, 5, 13);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (85, 5, 14);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (86, 5, 16);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (87, 5, 17);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (88, 5, 18);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (89, 5, 19);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (90, 5, 20);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (91, 5, 21);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (92, 5, 22);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (93, 5, 23);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (94, 5, 24);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (95, 5, 25);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (96, 6, 21);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (97, 6, 22);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (98, 6, 23);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (99, 6, 24);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (100, 6, 25);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (101, 7, 21);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (102, 7, 22);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (103, 7, 23);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (104, 7, 24);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (105, 7, 25);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (106, 8, 21);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (107, 8, 22);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (108, 8, 23);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (109, 8, 24);
INSERT INTO `ums_role_menu_relation` (`id`, `role_id`, `menu_id`) VALUES (110, 8, 25);
COMMIT;

-- ----------------------------
-- Table structure for ums_role_resource_relation
-- ----------------------------
DROP TABLE IF EXISTS `ums_role_resource_relation`;
CREATE TABLE `ums_role_resource_relation` (
                                              `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                              `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
                                              `resource_id` bigint(20) DEFAULT NULL COMMENT '资源ID',
                                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COMMENT='后台角色资源关系表';

-- ----------------------------
-- Records of ums_role_resource_relation
-- ----------------------------
BEGIN;
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (103, 2, 8);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (104, 2, 9);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (105, 2, 10);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (106, 2, 11);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (107, 2, 12);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (142, 5, 1);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (143, 5, 2);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (144, 5, 3);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (145, 5, 4);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (146, 5, 5);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (147, 5, 6);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (148, 5, 8);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (149, 5, 9);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (150, 5, 10);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (151, 5, 11);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (152, 5, 12);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (153, 5, 13);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (154, 5, 14);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (155, 5, 15);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (156, 5, 16);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (157, 5, 17);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (158, 5, 18);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (159, 5, 19);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (160, 5, 20);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (161, 5, 21);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (162, 5, 22);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (163, 5, 23);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (164, 5, 24);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (165, 5, 25);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (166, 5, 26);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (167, 5, 27);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (168, 5, 28);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (169, 5, 29);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (170, 1, 1);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (171, 1, 2);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (172, 1, 3);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (173, 1, 4);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (174, 1, 5);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (175, 1, 6);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (176, 1, 23);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (177, 1, 24);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (178, 6, 25);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (179, 6, 26);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (180, 6, 27);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (181, 6, 28);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (182, 6, 29);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (205, 7, 25);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (206, 7, 26);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (207, 7, 27);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (208, 7, 28);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (209, 7, 29);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (210, 7, 31);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (211, 8, 25);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (212, 8, 26);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (213, 8, 27);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (214, 8, 28);
INSERT INTO `ums_role_resource_relation` (`id`, `role_id`, `resource_id`) VALUES (215, 8, 29);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
